|
KMID : 1149220170250010039
|
|
Korean Journal of Oriental Medical Prescription
2017 Volume.25 No. 1 p.39 ~ p.49
|
|
|
A study on the database structure of medical records - Focusing on Yakazud?mei's medical records -
|
|
Kim Sung-Won
Kim Ki-Wook
Lee Byung-Wook
|
|
|
Abstract
|
|
|
Objectives : The contents of the literature associated with the medical records were entered into the database. We want to find the structure and search methods for efficient utilization of the database.
Methods : The contents were entered into the database using the 'Access 2014 of the MS'. The Query Sentences were created and utilized for a search.
Results : We could find information about the prescriptions, medical records and patients by the herbs and symptom combinations using the single table named 'Integrated Knowledge' and queries. Integrated Knowledge is a table that gathered patient information, prescription information and symptom information together.
Conclusions : If you store patient, prescription and symptom information on a single table, you could search and use the results by various combinations of the various elements included in the table. These results could help curing patients on the basis of evidence-based treatment at the clinics.
|
|
|
KEYWORD
|
|
|
Medical records , Database , Query , Data structure
|
|
|
FullTexts / Linksout information
|
|
|
|
|
|
Listed journal information
|
|
|